class CreateLeechdoms < ActiveRecord::Migration
  def self.up
    create_table :leechdoms do |t|
      t.string :generic_name, :proprietary_name, :english_name, :chinese_name, :chemical_name, :formulation, :molecular_weight, :spec
      t.string :application_and_dosage, :pregnancy_and_lactation, :intant, :lderly_patient, :storage, :packs, :validity, :standard, :batch_no
      t.text :composition, :description, :indications, :adverse_reaction, :contraindications, :precautions, :interactions, :overdosage
      t.text :pharmacology, :phamacokinetics
      t.decimal :price, :precision => 8, :scali => 2, :default => 0
      t.timestamps
    end
  end

  def self.down
    drop_table :leechdoms
  end
end
